Aminet 14

home *** CD-ROM | disk | FTP | other *** search

/ Aminet 14 / Aminet 14 - Oct 1996.iso / TCalc / Français / TurboCalc2 / TurboCalc.HELP < prev next >

Wrap

Text File | 1995-10-05 | 44KB | 1,012 lines

Welcome to the OnLine Help of TurboCalcV2.0. Its condensed information is designed to serve you as reference in your every day work with this program. Most points are limited to the absolutely necessary information; detailed descriptions and further hints can be found in your manual. Close this window with the closing gadget in the top left corner and choose the desired topic in the Help pull down menu. # <Functionkey> <Shift>+<Key> ----------------------------------------- F1 Recalculate Save F2 Edit Define Name F3 Copy Series F4 Paste Generate Chart F5 Goto Play Macro F6 Find DB-Find F7 Sort Range DB-Sort F8 Extract DB-Delete F9 Def. Database Def. Criteria F10 Command Iconify Del: (not in "Edit-Mode") Delete Cell/Block - it appears a window to select different options. Help: displays the online-help. <Ctrl>-K Removes the rest of the input-line starting at the cursor-position <Ctrl>-L Left-align text <Ctrl>-R Right-align text <Ctrl>-C Center text <Ctrl>-N Textstyle: Normal <Ctrl>-B Textstyle: Bold <Ctrl>-I Textstyle: Italic <Ctrl>-U Textstyle: Underline <Ctrl>-0 Textcolor: Standard <Ctrl>-1 to 8 Textcolor: Select color1 to 8 <Ctrl>-* toggles the display between "Display For- mulas" and "Values" (see <Options-Display>). <Ctrl>-# activates/deactivates the cell grid (see <Options-Display>). # MENUTITLE PROJECT: NEW Opens a new, empty sheet window. This sheet will receive the name "Sheet1" (1,2...) and the standard settings. If a file with the name "S:TurboCalc.CFG" exist, it will be loaded and the settings and also the contents will be taken over into the new sheet. In this way the user is able to define his personal standard settings and stan- dard sheets (refer to <Options-Config-Save>). OPEN Opens a new sheet window and loads an already existing TurboCalc sheet. If this item is called from a new sheet, where no input has been done so far (e.g. after a <Project-New> or the start of TurboCalc) the opened sheet will be loaded in this window (this will avoid the confusing, unnecessary <Sheet1> window, if a file is loaded right after the start). The standard-file requester of Commodore will be opened and the file can be selected with the mouse. Select the path and file name with a click and confirm with >Ok< (For detailed usage, see user manual of your Amiga). CLOSE Closes the current sheet and all corresponding windows. If there are any changes since the last saving, a re- quester will be opened with the possibility to save the file before closing or to abort the whole operation. If you try to close the last sheet window, TurboCalc will ask you, if you really want to quit or whether a new, empty sheet window should be opened. SAVE Saves the sheet under its current name (this is the name by which the file was loaded, or by which it was saved the last time - it is shown as menu title). If this file is a new one and has not been saved yet (e.g. the name is Sheet1), <Save as> is automatically called so that you can determine a file name. SAVE AS Saves the sheet as a TurboCalc-sheet on diskette or hard- disk... .The standard-file requester of Commodore appears to enter the file name and path. The new name will be used as new sheet name (for the next <Save>) and also be shown in the window title. IMPORT FROM ProCalc - SYLK (Excel) - CSV (ASC) Allows the import (loading) of sheets which have not been created by TurboCalc A requester is opened to select the desired file. (For de- tails see appendix "Foreign Formats") EXPORT TO SYLK (Excel) - CSV (ASC) Tab This menu item allows to save the data of the current sheet in a foreign format, so it can be used by other pro- grams. This is the counterpart of <Project-Import from>. PRINT This opens a window to set some printing parameters and the gadget <Print> down on the left, which starts the print-out. For further settings also refer to <Format- Print Format> and <Options-Print Range>. A description of all possible parameters can be found in the user manual. ABOUT Gives information about version number, author and dis- tributor. ICONIFY With this item all TurboCalc-windows will be closed temp- orarily and TurboCalc will be put to the background. On the workbench a TurboCalc-icon (up to kickstart 1.3: a window) appears. With a double click on it, TurboCalc is "awakened" again. The windows will be opened as they were before the iconification and the work can be continued. From OS2.0, you will also find an entry in the workbench menu "Tools". Its selection calls TurboCalc again. This can be very meaningful if you have started TurboCalc on the workbench and you decide to do something else for a while. In this case you can hide TurboCalc and work with the workbench. If you want to continue your work with TurboCalc, a double click on the above mentioned icon (or window) or a simple menu selection will be suf- ficient. QUIT This menu item terminates the work with TurboCalc. If you have opened unsaved sheets you will be reminded that you still have the possibility to save them. # MENUTITLE EDIT: CUT Copies the marked range into the intermediate memory (for <Paste>) and empties the selected cells.This operation can be made undone with <Paste>. COPY Copies the marked range into the intermediate memory (for <Paste>). In contrast to <Cut> the source range is not changed by this operation. PASTE Inserts the buffer, which was created by <Cut> or <Copy>, at the current position - already filled cells will be overwritten. If a block has been marked before <Paste>, exactly this block will be filled up now. If it is smaller than the copied range, the superfluous part will be left out. If it is larger, the copied range will be added, as often as necessary, beside or below, until the block is filled. While inserting formulas the relative cell references will be adapted automatically. This can also be performed between different sheets, that means <Copy> in one sheet and <Paste> in another - to transport the data. PASTE ONLY With this command you can paste only a part of the infor- mation of the block you have cut or copied (e.g. only the values or the formatting) FORMAT: Only the format of the block is pasted to the new block, the values and the formulas of the new range will not be changed. This is useful if you want to refor- mat a range. VALUES: With this command only the values will be pasted. (Existing formulas of the new block will be removed). The format of the new block will be kept. VALUES & FORMULAS: With this command only the values and the formulas will be pasted. The old format will be kept. This is useful to copy data to an already formatted block. It is the counterpart to Format; both together re- sult in <Paste>. CLEAR CONTENTS Deletes parts of the information of the marked block or the current cell: ALL: Deletes the whole cell inclusive its formats. This corresponds to <Cut>, but the range will not be copied to the buffer and therefore <Paste> is not possible. FORMAT: Deletes all format instructions and puts them back to standard; the cell contents and the formula stay preserved. FORMULAS (VALUES REMAIN): Deletes only existing formulas. The value which was calculated by the formula stays pre- served (see hint). VALUES: Deletes the complete contents (that means values and formulas) - only the formatting stays preserved. REMOVE CELLS Removes cells, complete columns or rows. A window for the selection (and for a security request) appears. COMPLETE COLUMNS: Deletes the column in which the cursor is located and all columns, which belong to one block. The other columns move up accordingly. COMPLETE ROWS: Like "Columns", but for rows. BLOCK LEFT: Deletes the block (or the current cell) and shifts all data on the right of the block automatically to the left. BLOCK UP: Like "Block left", but only the data below will be shifted upwards. At the same time all relative cell references will be adapted in a way that they refer to the correct cells. (A reference to a deleted cell is replaced by #REFERENCE!). INSERT CELLS Inserts (in contrast to <Remove cells>) cells or complete columns/rows. COMPLETE COLUMN: Inserts one column (or a few, correspond ing to the block width) at the cursor/block position. The other columns move down accordingly. COMPLETE ROWS: Like above, but for rows. BLOCK RIGHT: Inserts an empty field in size and place of the block (or current cell), and shifts all data below and to the right of the block automatically to the right. BLOCK DOWN: Like above, but the data will be shifted down wards. FILL Fills in a block according to the entry of the first cell. INSERT DATA TURBOCALC - PROCALC - SYLK (EXCEL) - CSV (ASC) With this menu item previously saved sheets can be in- serted into the current one: A file requester appears to select the file, which will then be inserted from the cur- rent cursor position on (or from the top left corner of a marked range). "TurboCalc" is the standard file-format of TurboCalc, which is read with <Project-Open> and written with <Project-Save>. All others are foreign formats. SAVE BLOCK AS SYLK (EXCEL) - CSV (ASC) TAB - CSV (ASC) This menu item works similar to <Project-Save as> or <Project-Export as>, but only the current block will be saved as a new sheet. Hence, parts of the sheet can be saved as a new sheet or as data (e.g. in the format CSV for a word-processing program). TRANSPOSE This instruction transposes a square range, that means the block will be mirrored at the diagonal. TRANSLATE FORMULAS TO GERMAN TO ENGLISH TurboCalc allows the input of formula- and macro-instruc- tions in German and English. With these two instructions the formulas and macros can be transferred to the appro- priate language. # MENUTITLE COMMAND: PASTE FORMULA, MACRO AND NAME Inserts a formula, a macro instruction or a definite name into the current input cell and changes automatically to the editing mode. A window with a list of all existing formulas (with pa- rameters) appears. With a click upon a formula and >Ok< the formula will be inserted at the current position (if you have not started an input yet, a "=" will be inserted automatically, which is obligatory at the beginning of each formula). If the inserted formula needs a parameter, the cursor will be located behind the "(" opening bracket, otherwise the cursor can be found behind the ")" closing bracket. DEFINE NAMES Here, names for cells, ranges or constant data can be de- termined. This instruction is also used to change or de- lete names! This is of advantage if you deal with frequently used cells/ranges. It facilitates the input and readability. (e.g. totalkm for C10 and in C12: =0.5*totalkm) To define a name a window appears, where all existing names are listed on the left side. On the right side, there are two text fields: the first is >Name< with the (new) name and the second is >Contents< with the con- tents, that is (or should be) assigned to the name. In the >Type<-field, you can determine the type of ob- ject, which receives the specified name (macro, criteria, etc). With a click on >Ok<, this assignment (name->contents) will be stored (if the name has already been defined be- fore, the old contents will be overwritten). The same is done by >Add<, but the window stays opened for further entries. >Delete< will delete the current name from the list, if it existed there. With a click on an entry of the list, names- and contents- fields will be changed according to the entry (like this, an easy changing or deleting is possible). FIND Allows the search for a special string in formulas and texts of the sheet. If the operation was successful, the cursor will be moved into this cell, otherwise it remains unchanged. If a block is selected, the search is limited to the cells within the block. The following window is opened: TEXT: Here, you enter the text which shall be searched for. BY ROWS/ BY COLUMNS: Determines if TurboCalc searches linewise or columnwise. The standard search is line-by- line, but if you want to search in a database-column, it is advisable to select columns. COMPARE PART/ALL: Using "Part" it is sufficient that the text -as a part of a text or formula- is a component of a cell. if you have selected "All", the text must be identi- cal in all characters. CASE SENSITIVITY: If selected, capitalization and use of initial letters must be same, otherwise it is sufficient, if only the letters are corresponding. GOTO Opens a window that allows to change the current cell. Se- lect a name from the list or enter the cell or the block (or the name) directly. Hint: Instead of selecting this menu item, you can also press <F5> or simply click on the "status-field" (i.e. the field the cell-position is printed in). SHOW ACTIVE CELL Scrolls the visible range, so that the current cell is visible again (In case the screen has been scrolled be- fore with the scrollbars at the left and bottom margin). RECALCULATE Recalculates the sheet with all its formulas. Above all, this is very useful if >automatic recalculation< (in <Option-Sheet>) is switched off. # MENUTITLE FORMAT: With the help of the following instructions you can deter- mine the sheet's format, that means the appearance of cells or cell ranges. All menu items refer to the current cell, or if a block is marked to that block (thus to all cells of the block). If complete rows or columns are marked (e.g. with a click on the line- or column titles) and a certain format is se- lected afterwards, the formatting only refers to the occu- pied cells of this range. The corresponding line- or col- umn format will be changed accordingly. If you create new cells in this row or column (e.g. text input), they will be formatted accordingly. NUMERIC FORMAT With "numeric format" you determine the format that should be use for displaying numbers, time, date. For this purpose, the following window is opened: On the left you find some gadgets. Selecting one of these gadgets sets the list to the beginning of the appropriate numeric type (normal notation, scientific notation, per- cent notation, currencies, date- and time formats). On the right you find a list of all available numeric for mats. Select the desired format with a double click (or click and >Ok<) ALIGNMENT Here, you can select the vertical and horizontal align ment of the cell contents resp. the block. With the se- lection of a block you determine the format of the whole block (In this case, TurboCalc preselects its settings in the requester. If the formats are different no item will be marked). A click on >OK< only changes those settings, which had been explicitly selected before. If you did not determine a new formatting and click on >OK<, the previ- ous alignment settings are kept unchanged. FONT With this item you can select the font and the font-style of the selected cell or block. With the selection of a block the format of the whole block is determined. (In this case, TurboCalc preselects its settings in the re- quester. If the formats are different no item will be marked). A click on >OK< only changes those settings, which had been explicitly selected before. If you did not determine a new formatting and click on >OK<, the previ- ous alignment settings are kept unchanged. COLORS Here you can change the text- and the background color of a cell or a block. A window with colored rectangles appears, containing a >Default< field for text- and background color. "Default" ("Dft") corresponds to the normal text- and background color (black-and-white respectively). A click on the desired color (or >Default<) makes it appear on the left, in the preview field. A click on >Ok< accepts the new color(s). PATTERN Here you can change the background pattern of a cell or a block. A window with 16 different patterns appear. The first (black) one corresponds to "no pattern", i.e. the back ground will appear white or in the color selected via <Format-Colors> (although you will see a black preview- field). A click on the desired pattern makes it appear on the right, in the preview field (for this preview the back ground-color is expected to be white - in your sheet this will change to the cells' background color). A click on >Ok< accepts this (new) pattern. FRAME With this option you can determine the frame of a cell or the current range. Here you can select the thickness of the respective frame part (left, right, above, below) >Ok< changes the frame thickness for all cells. <Around block> changes the frame thickness for the mar- gins of the selected block only. CELL PROTECTION With this menu item you can change the protection fea- tures of the current cell or the current block. WRITEPROTECTION ENABLED: If this item is selected and the protection is switched on with <Options-Protection Flags>, this cell can no longer be overwritten or de- leted. (This flag is by default set to "on" for every cell, the flag has to be deleted only for those, which shall not be protected - and most of the time there are only a few!) HIDE FORMULA: If this item is selected and the protection is switched on with <Options-Protection Flags>, there will be no formula shown in the status line. The field remains empty. This is very useful, if only the value of a formula should be available for others, but the formula itself should stay private. Hint: As mentioned above, both features are sensless if you do not activate >Enable Protection< in the menu <Options-Protection Flags>. Otherwise (which is the regu- lar case) all cells can be edited freely. COLUMN WIDTH With this option you can set the width of the current col- umn(s). TurboCalc asks for the width in characters. Num- bers with decimal points can also be entered (.0, .125,25,...) to define the width more precisely. If the value is specified too low (<1) or too high, it will be ignored. 0 means standard width. ROW HEIGHT Here you can set the height of the current cell(s). You will be asked for the height in lines. Numbers with deci- mal points can be entered (.0, .125,25,...) as well to de- fine the height more precisely. If the value is specified too low (<1) or too high, it will be ignored. 0 means standard height. FREEZE With this command you can define rows and/or columns that shall be frozen, i.e. these lines/columns will be dis- played on top/left of the window even if the range (below) is scrolled. Thus it is a kind of "Title". Before selecting this menu item, put the cell cursor in the cell below and right to the lines/columns that shall be frozen. All lines above the current cell and all col- umns on the right will get the new title (In other words: Move the cursor to the first cell that is outside of the range to be fixed.). UNFREEZE: Put the cursor in cell A1 before selecting <Freeze>. FREEZE LINES ONLY: Move the cursor to the column A one line below the new "title-lines". FREEZE COLUMNS ONLY: Move the cursor to line 1 and "Column+1".. of the part to be frozen. HIDE COLUMN(S) - ROW(S) With this menu item you can hide columns resp. rows. Move the cell cursor to the column/row you want to hide and select the respective menu item. (If a block is marked when executing this command, all columns/rows hav- ing one (or more) cells marked will be hidden.) SHOW COLUMN(S) - ROW(S) Columns or rows which were hidden before (see above) can here be redisplayed. For this, move the cursor to the de- sired column/line (or mark the range) and then call up the corresponding menu item. DEFAULT FONT Here you can determine the standard font for the current sheet. It will be used in all cells that have not re- ceived a distinct font or the "default character-set". PRINT FORMAT Here you can define some settings that determine the print image. (This windows can also be called from the <Project-Print>-requester). MARGINS: In the four number fields you can enter the re_ spective margins (in centimeters or inches, see below). This allows a precise positioning within the printout- page (The paper format must be set before the print-out is started with <Project-Print>). FONT: Here you can choose from three printer fonts, which become smaller from the top to the bottom. Pica (10 characters per inch) Elite (12 characters per inch) and Condensed (15 characters per inch) HEADER/FOOTER: Here you can set, whether a top or bottom line shall be printed and (behind that) determine the text of this line. You can use the following "control characters" in the texts: %P prints out the appropriate page number instead of these two letters %D will be replaced by the current date %N results in the name of the file, which will be printed. %% results in a percent character (if you should need one for your text). TITLES: Here, you can determine that the corresponding column titles (A,B,...) appear in the first line of each page on the print. Furthermore you can provide the print- out with the line numbers (1,2,3...) on the left. With the next gadget you can create the following 3 lines (with repeated clicks): NO GRID: Prints the normal sheet (without raster). GRID (LINE): The sheet is printed with a raster. As verti- cal separator a special character is inserted ("|"). The whole line is horizontally underlined. Underlined text will thus not be visible as underlined. RASTER (UNDERL.): This also adds a raster, but the hori- zontal line will be produced as a line of minus charac ters "-". The advantage is that underlinements are also visible in this case (but it needs twice as much lines and therefore pages for the print). Most of the time the print image gets more illegible. # MENUTITLE DATA: FIND Searches for the next entry in the current database, which matches the current criteria. Therefore database- and search-criterion-range must be defined, see below. If the cursor is located in a database range, the search starts in the line below the cursor. If the end of the da- tabase range is reached without a result, TurboCalc asks whether the search should be continued from the beginning (if the search has been started from the beginning, it will be indicated that no matching entry could be found). If a corresponding line is found it will be marked as a block and the search is stopped. Another <Find> continues the search for the next entry. EXTRACT Copies all database lines, which matches the current cri- teria (see there) to a new position, in fact to the cur- rent cursor position! (The former contents of the data- base range stays preserved!). DELETE Deletes all data records which conform to the current search criterion (see there). The remaining data records move up accordingly and the da- tabase range is reduced. SORT DATABASE ASCENDING - DESCENDING Sorts the current database range in ascending (or in de- scending) order depending on the column where the cursor is located (the location must be within the database range, otherwise the instruction will be ignored). DEFINE DATABASE Defines the current marked block as database range. It re- ceives the name "DATABASE" (see "Names"). The cells in the first database line should contain the row-titles of the data-structure while the remaining lines represent the database contents. DEFINE CRITERIA Defines the current criteria range. It receives the name "CRITERIA". The first line should consist of row titles (as used in the database) and the remaining lines should consist of comparative criteria. Here a short summary: Empty cells: are always identical Number, date, time or text: need complete identity (texts allow the search with the patterns "*" and "?"). Comparisons: Start with ">",">=", "<", "<=" or "<>", fol- lowed by a formula expression. If all cells of one line of the criteria range correspond to the respective values of its title field, this line will be marked as "found" SORT RANGE Allows the sorting of any range except databases (which are sorted with <Data-Sort Database>). This command re- quires a block as parameter, otherwise the selection of this menu item will be ignored. The following window appears: SORT DATA (ROWS/COLUMNS): Here you can choose between sorting of lines or columns. The setting adheres to the size of the block: If the width is bigger than the height, it will be assumed that the columns should be sorted, otherwise rows is selected (In most cases this presetting should be suitable. DIRECTION: toggles between ascending/descending sort-or der. BY COLUMN/ROW: Normally the sorting adheres to the line totally on the left or the column on top of the block. If you want to sort a block according to a different line or column, you may change this information here: Enter any cell of the line or column the sorting shall adhere to (if you sort linewise only the leading column letter is of importance while the columnwise sorting requires the rownumber only. The rest can be chosen at will and even be outside the sort range). If the important component for the sort-process is out side the sort range, the sorting will be aborted. CREATE SERIES Allows the automatical fill-in of changing values (e.g. number- or date sequences). Select the block to be filled (with initial data in the first column/line), then call his menu and set parameters as desired: DATA IN (ROWS/COLUMNS): Here you can determine, if the data-series should be calculated line-by-line or column- by-column (This flag will be preset by TurboCalc accord- ing to the size of the block.) INCREMENT: The increment represents the unit by which the starting value is raised step-by step (negative values for diminishing are possible as well). DATATYPE: Determines, by which method the initial value should be increased: Arithmetical: The increment will be added to the start value (e.g.: 1,3,5,7,9...; with an increment of two). Geometrical: The start value will be multiplied con- stantly by the increment (e.g.: 1,2,4,8,16 - increment two). Day, Weekday, Month, Year: This method requires a date as initial value. It will be increased respectively dimin- ished by the selected preiod of time (days, month...). If you have activated the weekdays option, Sundays will be left out (counting sequence: Saturday, Monday, Tues- day...). CREATE CHART Select a block first and then call this menu item. A win- dow for the selection of the chart type appears and fol- lowed by a second window for the setting of the parame- ters. Finally a new window with the chart is opened. Details about both requesters can be looked up in "presentation-chart type" and "presentation-parameter" in the description of the chart menu or in chapter "Chart". SHOW CHART Already created charts can be closed temporarily with <Chart-Hide> or a click on the "close-gadget" of the chart-window. With this instruction all charts of the sheet (the opened and the "closed" ones) will be shown in a list-window and can be selected with a double click or a click on >Ok<. If the window is open at the moment, it will be activated and put to the front, otherwise the window will be re- opened. # MENUTITLE OPTIONS: PRINT RANGE These two menu items set the print range, that means the part of the sheet which should be printed by <Project- Print>: (The print range is determined by these options only and not by a simple selection of a block before printing. Thus, you can determine the print range for several print-outs. Of course, the last setting stays preserved after saving and reloading.) CURRENT BLOCK The currently marked block becomes the actual print range. The print-out is now limited to this block. If no block is marked, an error message will appear. ALL The whole sheet will be marked as print range. The print starts with cell A1 and ends in the last data-filled cell at the left bottom (You can get there with <Ctrl>-<Down> followed by <Ctrl><Right>). SHEET With the help of this menu item the general parameters of the sheet may be set: MAX. SHEETSIZE: Here you can determine the maximum sheet size. Although the size of TurboCalc is theoretically un- limited, a top boundary must be entered. This has been done mainly for your own protection, be- cause very large sheets could need a lot of storage ca- pacity (This can be the case if large ranges have been formatted by mistake). Therefore it is advisable not to select an unnecessary size for the sheet at the beginning. If the sheet is (or becomes) too small for your needs, you may increase this value later (also in an already existing sheet.) WIDTH: Determines the width of the sheet between 20 an 700 (700 is the highest value you can express with two letters, column ZY). Default is 400. HEIGHT: Indicates the height of the sheet (between 40 an 9999999, that means nearly unlimited. Even if you like to use only one cell in every row, you will need more than 200 MB of memory!!!). Here, default is 4000. CALCULATION: MANUALLY: Switches off the automatical calcu- lation. That is advisable for larger sheets or many in puts. When all inputs are made, the calculation can be started manually with <Command-Recalculate> or simply with <Shift>-<F1>. <RETURN>: MOVE CURSOR: Determines, whether (and in which direction) the cursor should be moved when you press <Return>. Default is "Down". GENERATE ICONS: If an icon should be added to the file when you save your sheet, you have to select this option. The icons allow an easy file-handling using the work bench, but need diskspace as well. So, if you always start TurboCalc before and read the files from there by means of <Project-Open>, it will be advisable to switch off this option. DISPLAY This instruction opens a window to determine the display- options for the current sheet-window. SHOW TITLE: Here it can be determined if the row- or col- umn titles (A, B, C, 1,1,3,...) shall be shown. Normally set to "on". SHOW GRID: If selected, the cells will be bordered by aux- iliary lines. This facilitates the location of distinct cells, but can be confusing in some sheets. Furthermore it reduces the scrolling speed. SHOW TOOLBAR: Shows the toolbar to allow an easy selec- tion of the most frequently used commands. SHOW FORMULA INSTEAD OF VALUES: If selected, TurboCalc displays the formula instead of the values in all cells containing such a expression. This can be very useful for the input or the editing of formulas. If macros are entered, these will be shown (and not the result as most macros do not return one). If this option is activated, the values (mostly Booleans) will be shown here (e.g. the result of LOAD; REQUEST...). SHOW ZERO: Here, it can be determined, if zero values should be displayed (0 or 0.00), or if the cells should stay empty. Normally they are shown. LOCALE These options allow the adaptation of TurboCalc to differ- ent countries. They mainly refer to the output, the input remains as usual: NUMERIC FORMAT: Here, the character of the decimal point or -comma and the separator for the thousands can be de- termined. The different possibilities should be presented sufficiently in the requester. SEPARATOR: Determines one out of three different formats for date values. ORDER: Here you can choose the order in which the date should be presented. CURRENCY: Determines the currency symbol that appears for numbers which are formatted as a currency value. You can choose among the standard currencies or define your own individual format with a click on >Prefix<: Prefix determines the part, which should stand in front of the number and suffix the part behind it (One of them or perhaps both can be empty). MEASURE: With this gadget you can choose whether the widths and heights (in <Project-Print> and <Format- Print Format>) shall be measured in cm's or in inches. PROTECTION FLAGS Here you can protect the whole sheet -or only parts of it- from write- or read access. ENABLE PROTECTION OF "PROTECTED" CELLS: If selected, cells which have been protected with <Format-Protection> (by default all cells are protected) cannot be overwrit- ten any longer. Furthermore, formulas can be protected against displaying with <Format-Protection>. If it is not activated, the limitations of <Format-Protec tion> are not valid and the cells are editable without re- strictions (For further details see <Format-Protection>). NEED PASSWORD TO OPEN THIS FILE: Here you can enter two passwords, which will be required when opening the file. The file will be loaded only when the entered password is identical with one of these two. PASSWORD FOR FUTURE CHANGES OF THIS OPTIONS: Here you can enter a password, that you have to reenter if you call <Options-Protection Flags>. Only in case of identity this window will be opened. This will be useful if you have protected the file (>Enable Protection of protected Cells<) and you do not want to have this option removed by somebody else. SHOW SHEET-WINDOW This menu item allows the fade-in of hidden windows or a quick change between windows in general. After calling this item a requester will be opened with a list of all available windows (including hidden ones). Just click on the desired window followed by >Ok< or per- form a double-click on the desired name. If you have selected a hidden window, it will be reopened and put to the front. Non-hidden windows will be put to the front only. HIDE SHEET-WINDOW Calling this menu item makes a certain window invisible to the user's eyes. You can hide special views of the current sheet created with <Options-New Window> or the last (original) window of the sheet. Of course, all the data, which belong to the sheet will be kept in memory. Only its visualization -the window- is faded out but can be redisplayed at any time by <Options- Show Window>. NEW SHEET-WINDOW Opens a new (second, third,...) window of the current sheet and puts it to the foreground. - It can now be used for input or editing in the same way as the first window. The display-options (see above) can be set separately for every window. ARRANGE WINDOWS If you have more than one window opened at the same time(of one or several sheets), you may want to rearrange them. With the following instructions the windows can be arranged in a new order. SHOW ALL Arranges all windows side by side. This is very suitable for a survey, but will lead (in case of many windows) to very small windows. STANDARD Arranges the windows in overlapping order, so that they are as big as possible. All windows further in the back ground only show their title-bars (or a part of it). Each window can be put into the foreground with the "to front" gadgets (in the right top corner of the windows). SCREEN - INDIVIDUAL With this menu item you can select the screen-type on which the TurboCalc windows should appear. From OS2.0 on, a requester will be opened (if the "asl.libary" V38 does exist) where the screen type, the size and the number of colors can be determined. It is built up similar to the setting of <Prefs>, see user manual. Otherwise only a window with a string gadget appears. Here you have to enter the height, width and depth of the screen (each separated by a comma). For further informa- tion, see appendix 'Screen modes'. SCREEN - ON WORKBENCH TurboCalc opens its windows on the workbench. If a screen was kept open before, it will be closed (the window posi- tions stay preserved). SCREEN - AS WB-COPY TurboCalc opens a screen, which is identical in size and color number to the workbench-screen. SCREEN - FONT This menu item is provided for the setting of the charac- ter set for all windows and menus. Therefore, a list with all available character sets and type sizes is shown. Please select the desired character-set and the size by mouseclick (or input in the text fields). For details about this requester, see <Format-Font>. SCREEN - COLORS Here, all colors of TurboCalc can be changed (and also the workbench colors, if TurboCalc should be located there). Simply click on the color you want to change and then use the three proportional-gadgets (shift regulators) for red, blue and green to adjust the color as desired. SCREEN - DEFAULT COLORS Sets the colors according to the "TurboCalc standard-set ting". This may be useful if you have mischanged the col- ors, or if the TurboCalc windows should be located on the workbench screen and strange colors are shown (e.g. for 1.3 users). SCREEN- SMARTREFRESH Selecting this item opens a window in which the smartre- fresh option can be turned on/off. SHEET-SMARTREFRESH: Enables the smartrefresh for sheet- windows. Once activated, it saves the contents of windows overlaid by others in an internal intermediate memory. Thus, the window need not to be rebuilt so many times, which speeds up the screen refresh. The hook to this process is that the buffering of the win dow needs additional memory space. If you have enough storage capacity (more than 1Meg), you should activate this option. CHART-SMARTREFRESH: Enables the smartrefresh for chart- windows. This option does not consume the memory the screen smartrefresh may require so you can leave it acti- vated even on a machine with minimum equipment (512K). CONFIG - LOAD Loads a setting that was saved with <Config-Save>. (The settings will be loaded automatically when starting Turbo Calc, so you have to select this item only in case of a change during a TurboCalc session and you want them back to standard.) CONFIG - SAVE Saves the current configuration which will be loaded auto- matically during the next start of TurboCalc. The configu- ration will be saved as "S:TurboCalc.CFG". Whenever you start TurboCalc, the program will try to load this file and use these settings. If this file cannot be opened, the standard configuration will be used instead. CONFIG - DELETE Deletes the file "S:TurboCalc.CFG" which was created be- fore with <Config-Save> (see above). The internal "standard"-file of TurboCalc will be used automatically when starting TurboCalc the next time. # MENUTITLE MACRO For details about macros, please refer to chapter "Macro/ARexx-Instructions". PLAY Opens a window and shows all available macros of Turbo- Calc. With a double click on the name (or click on >Ok<), the appropriate macro will be started. STOP PLAYING If you are executing a macro (recognizable by the changed screen title), it can be stopped with this menu item. Nevertheless the last instruction will be finished. RECORD Opens a window for the setting of the macro characteris- tics and accepts the following instructions as a new macro. For details, see chapter "Record Macro". MACRONAME: Please enter the macro-name here.This is the name that will be shown in the <Macro-Play> requester later. Try to choose a clear name, so that you can easily recognize the macro. WRITE MACRO TO: Here, you can select, if you want to rec- ord the macro to the current sheet or to a new macro work- sheet. TurboCalc provides both recording types (in con- trast to other spread-sheet programs). The recording in the current sheet is suitable, if only a few macros shall be recorded. In this case you do not need an extra sheet, which has to be loaded and saved to gether with the one that is affected by the macro. If you intend to create a lot of macros, or use macros in gen- eral for more than one sheet, you may prefer the saving of macros in an external sheet. Please note that you have to save and load this sheet separately. POSITION: Here you can determine a definite position (the cursor position is preset), where the macro shall be writ- ten to. As default setting TurboCalc selects the next new and unoccupied column (in the current sheet from column BA on, if this column is not occupied yet). To SAVE CURSORMOVEMENTS RELATIVELY determines, whether the cursor positions shall be saved absolutely (e.g. C5) or relatively (e.g. 3 down, 2 left...). If you have set all parameters, click on >Ok< and the re- cording will be started (if necessary, the new macro sheet is opened)!. In the screen bar appears a corre- sponding text indicating that the recording is in prog- ress (if the bar is not overlaid by a window). After you have recorded all necessary steps, you can stop the recording with the menu item <Macro-Stop Recording>. The message on the screen bar disappears. STOP RECORDING If you are running a macro-recording (recognizable by the changed screen title), it can be stopped with this menu item. DEFINE NAME This menu item corresponds to <Command-Define Name>. It has been added to the macro menu to shorten the defini- tion procedure. # MENUTITLE HELP: INFO Opens a window which displays some information about the version and revision of your TurboCalc copy and the current sheets. HELP ITEMS The selection of an item in this pull-down menu opens a window in which a brief summary of the most important points of the respective topic is given. A more detailed explanation and further information about a certain function of TurboCalc can be found in this manual.